Pandas Profiling Report

Dataset statistics

Number of variables	24
Number of observations	848411
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	2442
Duplicate rows (%)	0.3%
Total size in memory	113.3 MiB
Average record size in memory	140.0 B

Variable types

DateTime	1
Numeric	22
Categorical	1

Alerts

Dataset has 2442 (0.3%) duplicate rows	Duplicates
`RoomTemperature` is highly correlated with `RelativeHumiditySupplyAir` and 1 other fields	High correlation
`HeaterPerc` is highly correlated with `HeatingPower`	High correlation
`CoolerPerc` is highly correlated with `CoolingPower`	High correlation
`TempSupplyAir` is highly correlated with `RelativeHumiditySupplyAir` and 1 other fields	High correlation
`RelativeHumiditySupplyAir` is highly correlated with `RoomTemperature` and 3 other fields	High correlation
`HeatingPower` is highly correlated with `HeaterPerc` and 1 other fields	High correlation
`CoolingPower` is highly correlated with `CoolerPerc`	High correlation
`AirTemperature` is highly correlated with `RoomTemperature` and 4 other fields	High correlation
`BrightnessNorth` is highly correlated with `AirTemperature` and 5 other fields	High correlation
`BrightnessEast` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`BrightnessSouth` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`BrightnessWest` is highly correlated with `AirTemperature` and 5 other fields	High correlation
`dwpt` is highly correlated with `RelativeHumiditySupplyAir` and 1 other fields	High correlation
`rhum` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`tsun` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`RoomTemperature` is highly correlated with `RelativeHumiditySupplyAir`	High correlation
`HeaterPerc` is highly correlated with `HeatingPower`	High correlation
`TempSupplyAir` is highly correlated with `RelativeHumiditySupplyAir` and 1 other fields	High correlation
`RelativeHumiditySupplyAir` is highly correlated with `RoomTemperature` and 3 other fields	High correlation
`HeatingPower` is highly correlated with `HeaterPerc` and 1 other fields	High correlation
`AirTemperature` is highly correlated with `RelativeHumiditySupplyAir` and 4 other fields	High correlation
`BrightnessNorth` is highly correlated with `AirTemperature` and 5 other fields	High correlation
`BrightnessEast` is highly correlated with `BrightnessNorth` and 3 other fields	High correlation
`BrightnessSouth` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`BrightnessWest` is highly correlated with `AirTemperature` and 4 other fields	High correlation
`dwpt` is highly correlated with `RelativeHumiditySupplyAir` and 1 other fields	High correlation
`rhum` is highly correlated with `AirTemperature` and 5 other fields	High correlation
`tsun` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`HeaterPerc` is highly correlated with `HeatingPower`	High correlation
`CoolerPerc` is highly correlated with `CoolingPower`	High correlation
`TempSupplyAir` is highly correlated with `RelativeHumiditySupplyAir`	High correlation
`RelativeHumiditySupplyAir` is highly correlated with `TempSupplyAir`	High correlation
`HeatingPower` is highly correlated with `HeaterPerc`	High correlation
`CoolingPower` is highly correlated with `CoolerPerc`	High correlation
`AirTemperature` is highly correlated with `dwpt`	High correlation
`BrightnessNorth` is highly correlated with `BrightnessEast` and 3 other fields	High correlation
`BrightnessEast` is highly correlated with `BrightnessNorth` and 3 other fields	High correlation
`BrightnessSouth` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`BrightnessWest` is highly correlated with `BrightnessNorth` and 3 other fields	High correlation
`dwpt` is highly correlated with `AirTemperature`	High correlation
`rhum` is highly correlated with `BrightnessSouth`	High correlation
`tsun` is highly correlated with `BrightnessNorth` and 3 other fields	High correlation
`HeaterPerc` is highly correlated with `HeatingPower`	High correlation
`CoolerPerc` is highly correlated with `CoolingPower`	High correlation
`TempSupplyAir` is highly correlated with `RelativeHumiditySupplyAir`	High correlation
`RelativeHumiditySupplyAir` is highly correlated with `TempSupplyAir`	High correlation
`HeatingPower` is highly correlated with `HeaterPerc`	High correlation
`CoolingPower` is highly correlated with `CoolerPerc`	High correlation
`AirTemperature` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`BrightnessNorth` is highly correlated with `AirTemperature` and 5 other fields	High correlation
`BrightnessEast` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`BrightnessSouth` is highly correlated with `AirTemperature` and 5 other fields	High correlation
`BrightnessWest` is highly correlated with `AirTemperature` and 5 other fields	High correlation
`dwpt` is highly correlated with `AirTemperature`	High correlation
`rhum` is highly correlated with `AirTemperature` and 5 other fields	High correlation
`tsun` is highly correlated with `BrightnessNorth` and 4 other fields	High correlation
`Room` has 142676 (16.8%) zeros	Zeros
`AirqualityPerc` has 160732 (18.9%) zeros	Zeros
`HeaterPerc` has 497718 (58.7%) zeros	Zeros
`CoolerPerc` has 684100 (80.6%) zeros	Zeros
`HeatingPower` has 635438 (74.9%) zeros	Zeros
`CoolingPower` has 754961 (89.0%) zeros	Zeros
`WindDirection` has 304105 (35.8%) zeros	Zeros
`BrightnessNorth` has 414876 (48.9%) zeros	Zeros
`BrightnessEast` has 414388 (48.8%) zeros	Zeros
`BrightnessSouth` has 415732 (49.0%) zeros	Zeros
`BrightnessWest` has 413508 (48.7%) zeros	Zeros
`BucketAttendees` has 818422 (96.5%) zeros	Zeros
`prcp` has 734300 (86.6%) zeros	Zeros
`tsun` has 568344 (67.0%) zeros	Zeros
`coco` has 15378 (1.8%) zeros	Zeros

Reproduction

Analysis started	2022-05-07 10:29:56.760841
Analysis finished	2022-05-07 10:35:32.280584
Duration	5 minutes and 35.52 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

df_index
Date

Distinct	140231
Distinct (%)	16.5%
Missing	0
Missing (%)	0.0%
Memory size	6.5 MiB

Minimum	2018-01-01 00:00:00
Maximum	2021-12-31 23:45:00

Histogram

Histogram with fixed size bins (bins=50)

Room
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.496415063

Minimum	0
Maximum	5
Zeros	142676
Zeros (%)	16.8%
Negative	0
Negative (%)	0.0%
Memory size	6.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.709282362
Coefficient of variation (CV)	0.6846947798
Kurtosis	-1.269891184
Mean	2.496415063
Median Absolute Deviation (MAD)	2
Skewness	0.0007064616374
Sum	2117986
Variance	2.921646193
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	142676	16.8%
3	141685	16.7%
4	141232	16.6%
5	141073	16.6%
2	140893	16.6%
1	140852	16.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	142676	16.8%
1	140852	16.6%
2	140893	16.6%
3	141685	16.7%
4	141232	16.6%
5	141073	16.6%

Value	Count	Frequency (%)
5	141073	16.6%
4	141232	16.6%
3	141685	16.7%
2	140893	16.6%
1	140852	16.6%
0	142676	16.8%

RoomTemperature
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	140
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.16507624

Minimum	12
Maximum	27.60000038
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	12
5-th percentile	20.10000038
Q1	21.60000038
median	22.29999924
Q3	22.89999962
95-th percentile	23.70000076
Maximum	27.60000038
Range	15.60000038
Interquartile range (IQR)	1.299999237

Descriptive statistics

Standard deviation	1.125211
Coefficient of variation (CV)	0.05076504084
Kurtosis	1.827415943
Mean	22.16507624
Median Absolute Deviation (MAD)	0.6000003815
Skewness	-0.8915127516
Sum	18805094.5
Variance	1.266099691
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.60000038	40454	4.8%
22.70000076	38621	4.6%
22.79999924	38426	4.5%
21.89999962	36934	4.4%
22.5	35537	4.2%
22.39999962	34150	4.0%
22.20000076	31962	3.8%
22.89999962	31417	3.7%
22.29999924	31306	3.7%
23	31054	3.7%
Other values (130)	498550	58.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	1	< 0.1%
12.19999981	2	< 0.1%
12.60000038	1	< 0.1%
12.80000019	1	< 0.1%
12.89999962	1	< 0.1%
13	1	< 0.1%
13.10000038	1	< 0.1%
13.30000019	2	< 0.1%
13.5	1	< 0.1%
13.80000019	1	< 0.1%

Value	Count	Frequency (%)
27.60000038	2	< 0.1%
27.5	2	< 0.1%
27.39999962	10	< 0.1%
27.29999924	5	< 0.1%
27.20000076	5	< 0.1%
27.10000038	3	< 0.1%
27	5	< 0.1%
26.89999962	13	< 0.1%
26.79999924	8	< 0.1%
26.70000076	8	< 0.1%

AirqualityPerc
Real number (ℝ_≥0)

ZEROS

Distinct	450
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.751688389

Minimum	0
Maximum	55.29999924
Zeros	160732
Zeros (%)	18.9%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.899999976
median	9.600000381
Q3	16.39999962
95-th percentile	20.5
Maximum	55.29999924
Range	55.29999924
Interquartile range (IQR)	14.49999964

Descriptive statistics

Standard deviation	7.78826046
Coefficient of variation (CV)	0.7986576426
Kurtosis	-0.7705032229
Mean	9.751688389
Median Absolute Deviation (MAD)	7.200000286
Skewness	0.3153251112
Sum	8273439.698
Variance	60.65699768
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	160732	18.9%
19.29999924	27266	3.2%
19.20000076	22273	2.6%
19.10000038	17185	2.0%
19.39999962	14324	1.7%
19.5	9727	1.1%
14.5	3723	0.4%
13.80000019	3701	0.4%
14.10000038	3675	0.4%
14.60000038	3603	0.4%
Other values (440)	582202	68.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	160732	18.9%
0.1000000015	2498	0.3%
0.200000003	2427	0.3%
0.3000000119	2687	0.3%
0.400000006	2686	0.3%
0.5	2508	0.3%
0.6000000238	2592	0.3%
0.6999999881	2658	0.3%
0.8000000119	2760	0.3%
0.8999999762	2697	0.3%

Value	Count	Frequency (%)
55.29999924	1	< 0.1%
55	1	< 0.1%
54.70000076	1	< 0.1%
53	1	< 0.1%
49.70000076	1	< 0.1%
49.59999847	1	< 0.1%
48	1	< 0.1%
47.90000153	1	< 0.1%
47	1	< 0.1%
46.79999924	1	< 0.1%

HeaterPerc
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	765
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.180841584

Minimum	0
Maximum	100
Zeros	497718
Zeros (%)	58.7%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1.700000048
95-th percentile	29
Maximum	100
Range	100
Interquartile range (IQR)	1.700000048

Descriptive statistics

Standard deviation	12.53284073
Coefficient of variation (CV)	2.997683714
Kurtosis	23.16786766
Mean	4.180841584
Median Absolute Deviation (MAD)	0
Skewness	4.499892235
Sum	3547071.989
Variance	157.0720978
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	497718	58.7%
1.600000024	58714	6.9%
1.700000048	51858	6.1%
1.799999952	28353	3.3%
1.5	19770	2.3%
0.8999999762	12528	1.5%
1.399999976	11394	1.3%
0.8000000119	9048	1.1%
1.299999952	6645	0.8%
2.599999905	5554	0.7%
Other values (755)	146829	17.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	497718	58.7%
0.1000000015	396	< 0.1%
0.200000003	60	< 0.1%
0.3000000119	36	< 0.1%
0.400000006	31	< 0.1%
0.5	30	< 0.1%
0.6000000238	96	< 0.1%
0.6999999881	948	0.1%
0.8000000119	9048	1.1%
0.8999999762	12528	1.5%

Value	Count	Frequency (%)
100	48	< 0.1%
99.90000153	6	< 0.1%
99.80000305	66	< 0.1%
99.69999695	2511	0.3%
99.59999847	811	0.1%
98.80000305	6	< 0.1%
98.19999695	6	< 0.1%
98.09999847	12	< 0.1%
98	12	< 0.1%
97.90000153	6	< 0.1%

CoolerPerc
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	477
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.029707539

Minimum	0
Maximum	100
Zeros	684100
Zeros (%)	80.6%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2.599999905
Maximum	100
Range	100
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.713343143
Coefficient of variation (CV)	6.519660088
Kurtosis	148.5233307
Mean	1.029707539
Median Absolute Deviation (MAD)	0
Skewness	11.40591812
Sum	873615.2028
Variance	45.06897354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	684100	80.6%
0.6999999881	34009	4.0%
0.6000000238	31195	3.7%
0.8000000119	19414	2.3%
0.5	18097	2.1%
0.8999999762	4782	0.6%
3.599999905	3711	0.4%
2.5	3576	0.4%
1.700000048	2651	0.3%
2.599999905	2371	0.3%
Other values (467)	44505	5.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	684100	80.6%
0.1000000015	45	< 0.1%
0.200000003	42	< 0.1%
0.3000000119	66	< 0.1%
0.400000006	884	0.1%
0.5	18097	2.1%
0.6000000238	31195	3.7%
0.6999999881	34009	4.0%
0.8000000119	19414	2.3%
0.8999999762	4782	0.6%

Value	Count	Frequency (%)
100	48	< 0.1%
99.90000153	354	< 0.1%
99.80000305	1242	0.1%
99.69999695	264	< 0.1%
97.69999695	24	< 0.1%
97.59999847	60	< 0.1%
97.5	24	< 0.1%
97.40000153	12	< 0.1%
97.30000305	6	< 0.1%
96.59999847	36	< 0.1%

TempSupplyAir
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1098
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.29385293

Minimum	0
Maximum	50
Zeros	174
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	18.20999908
Q1	19.27000046
median	20.27000046
Q3	21.15999985
95-th percentile	22.63999939
Maximum	50
Range	50
Interquartile range (IQR)	1.88999939

Descriptive statistics

Standard deviation	1.480688214
Coefficient of variation (CV)	0.07296239997
Kurtosis	14.6123209
Mean	20.29385293
Median Absolute Deviation (MAD)	0.9599990845
Skewness	0.0008916640072
Sum	17217528.06
Variance	2.192437649
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.20999908	14299	1.7%
19.40999985	12060	1.4%
18.94000053	11749	1.4%
19.68000031	10793	1.3%
20.01000023	9961	1.2%
20.61000061	9846	1.2%
20.54000092	9619	1.1%
20.87999916	9567	1.1%
19.01000023	9115	1.1%
20.75	9006	1.1%
Other values (1088)	742396	87.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	174	< 0.1%
6.610000134	6	< 0.1%
10.60999966	6	< 0.1%
10.64999962	6	< 0.1%
11.86999989	6	< 0.1%
12.60000038	6	< 0.1%
12.81000042	6	< 0.1%
13	6	< 0.1%
13.01000023	6	< 0.1%
13.17000008	6	< 0.1%

Value	Count	Frequency (%)
50	36	< 0.1%
34.72999954	6	< 0.1%
34.49000168	6	< 0.1%
28.28000069	6	< 0.1%
28.22999954	6	< 0.1%
28.21999931	6	< 0.1%
28.18000031	6	< 0.1%
28.10000038	6	< 0.1%
28.02000046	12	< 0.1%
27.88999939	6	< 0.1%

RelativeHumiditySupplyAir
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	204
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42.73846614

Minimum	0
Maximum	100
Zeros	138
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	38.79999924
Q1	41.40000153
median	43.29999924
Q3	44.29999924
95-th percentile	45.29999924
Maximum	100
Range	100
Interquartile range (IQR)	2.899997711

Descriptive statistics

Standard deviation	2.265540123
Coefficient of variation (CV)	0.05300939242
Kurtosis	55.27735138
Mean	42.73846614
Median Absolute Deviation (MAD)	1.299999237
Skewness	-0.3923251331
Sum	36259784.8
Variance	5.132671833
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44	33471	3.9%
44.40000153	27173	3.2%
43.90000153	26899	3.2%
43.5	23695	2.8%
44.5	23545	2.8%
43.59999847	23204	2.7%
44.29999924	22621	2.7%
44.79999924	21526	2.5%
44.70000076	19978	2.4%
43.70000076	19757	2.3%
Other values (194)	606542	71.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	138	< 0.1%
25.5	12	< 0.1%
25.70000076	6	< 0.1%
26	12	< 0.1%
26.10000038	12	< 0.1%
26.39999962	12	< 0.1%
26.5	6	< 0.1%
26.79999924	12	< 0.1%
27.10000038	6	< 0.1%
27.29999924	6	< 0.1%

Value	Count	Frequency (%)
100	72	< 0.1%
51.90000153	6	< 0.1%
51.40000153	72	< 0.1%
51.20000076	42	< 0.1%
51.09999847	24	< 0.1%
51	12	< 0.1%
50.79999924	6	< 0.1%
50.70000076	12	< 0.1%
50.59999847	6	< 0.1%
50.5	12	< 0.1%

HeatingPower
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	3425
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.48559189

Minimum	-4.699999809
Maximum	506.7000122
Zeros	635438
Zeros (%)	74.9%
Negative	7735
Negative (%)	0.9%
Memory size	3.2 MiB

Quantile statistics

Minimum	-4.699999809
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	136.5
Maximum	506.7000122
Range	511.400012
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	57.27389908
Coefficient of variation (CV)	2.162454942
Kurtosis	9.612288475
Mean	26.48559189
Median Absolute Deviation (MAD)	0
Skewness	2.808483601
Sum	22470667.5
Variance	3280.299316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	635438	74.9%
0.1000000015	1010	0.1%
66.40000153	524	0.1%
76.40000153	524	0.1%
65	522	0.1%
77.19999695	512	0.1%
76.59999847	493	0.1%
-4.300000191	492	0.1%
71.40000153	486	0.1%
77.5	475	0.1%
Other values (3415)	207935	24.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4.699999809	24	< 0.1%
-4.599999905	96	< 0.1%
-4.5	312	< 0.1%
-4.400000095	462	0.1%
-4.300000191	492	0.1%
-4.199999809	432	0.1%
-4.099999905	282	< 0.1%
-4	246	< 0.1%
-3.900000095	264	< 0.1%
-3.799999952	282	< 0.1%

Value	Count	Frequency (%)
506.7000122	6	< 0.1%
458.3999939	6	< 0.1%
451	6	< 0.1%
440.2000122	6	< 0.1%
439.3999939	6	< 0.1%
438.3999939	6	< 0.1%
437.3999939	6	< 0.1%
434.7999878	12	< 0.1%
434	6	< 0.1%
433.5	6	< 0.1%

CoolingPower
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	575
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.920204476

Minimum	0
Maximum	68.40000153
Zeros	754961
Zeros (%)	89.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	20.60000038
Maximum	68.40000153
Range	68.40000153
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.840014935
Coefficient of variation (CV)	3.562128419
Kurtosis	15.70216465
Mean	1.920204476
Median Absolute Deviation (MAD)	0
Skewness	3.886308908
Sum	1629122.6
Variance	46.78580475
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	754961	89.0%
0.200000003	4837	0.6%
0.3000000119	3837	0.5%
0.1000000015	2667	0.3%
0.400000006	2472	0.3%
0.5	1836	0.2%
0.6000000238	1488	0.2%
0.6999999881	1016	0.1%
0.8000000119	687	0.1%
23.10000038	605	0.1%
Other values (565)	74005	8.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	754961	89.0%
0.1000000015	2667	0.3%
0.200000003	4837	0.6%
0.3000000119	3837	0.5%
0.400000006	2472	0.3%
0.5	1836	0.2%
0.6000000238	1488	0.2%
0.6999999881	1016	0.1%
0.8000000119	687	0.1%
0.8999999762	390	< 0.1%

Value	Count	Frequency (%)
68.40000153	6	< 0.1%
68	6	< 0.1%
65.5	6	< 0.1%
65.40000153	6	< 0.1%
64.69999695	6	< 0.1%
63	6	< 0.1%
62.29999924	6	< 0.1%
62	6	< 0.1%
61.90000153	8	< 0.1%
61.70000076	6	< 0.1%

AirTemperature
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	563
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.6955221

Minimum	-16.10000038
Maximum	41.79999924
Zeros	1464
Zeros (%)	0.2%
Negative	37524
Negative (%)	4.4%
Memory size	3.2 MiB

Quantile statistics

Minimum	-16.10000038
5-th percentile	0.3000000119
Q1	5.5
median	10.89999962
Q3	17.29999924
95-th percentile	26.10000038
Maximum	41.79999924
Range	57.89999962
Interquartile range (IQR)	11.79999924

Descriptive statistics

Standard deviation	8.121736526
Coefficient of variation (CV)	0.6944312924
Kurtosis	-0.2079547197
Mean	11.6955221
Median Absolute Deviation (MAD)	5.800001144
Skewness	0.3211560845
Sum	9922609.599
Variance	65.96260071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.699999809	5655	0.7%
4.599999905	5104	0.6%
4.400000095	5065	0.6%
4	5033	0.6%
7.900000095	4989	0.6%
3.599999905	4978	0.6%
11.19999981	4880	0.6%
6.099999905	4838	0.6%
6.699999809	4752	0.6%
5.599999905	4743	0.6%
Other values (553)	798374	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-16.10000038	6	< 0.1%
-15.89999962	6	< 0.1%
-15.80000019	18	< 0.1%
-15.69999981	42	< 0.1%
-15.60000038	12	< 0.1%
-15.5	18	< 0.1%
-15.39999962	12	< 0.1%
-15.30000019	12	< 0.1%
-15.19999981	12	< 0.1%
-15.10000038	18	< 0.1%

Value	Count	Frequency (%)
41.79999924	12	< 0.1%
40.70000076	6	< 0.1%
40.59999847	12	< 0.1%
40.40000153	6	< 0.1%
40.09999847	6	< 0.1%
39.90000153	24	< 0.1%
39.70000076	12	< 0.1%
39.59999847	12	< 0.1%
39.5	6	< 0.1%
39.40000153	12	< 0.1%

WindDirection
Real number (ℝ_≥0)

ZEROS

Distinct	361
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	125.9108864

Minimum	0
Maximum	360
Zeros	304105
Zeros (%)	35.8%
Negative	0
Negative (%)	0.0%
Memory size	6.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	90
Q3	263
95-th percentile	311
Maximum	360
Range	360
Interquartile range (IQR)	263

Descriptive statistics

Standard deviation	119.4990649
Coefficient of variation (CV)	0.9490765128
Kurtosis	-1.510857247
Mean	125.9108864
Median Absolute Deviation (MAD)	90
Skewness	0.2848586636
Sum	106824181
Variance	14280.02652
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	304105	35.8%
270	144461	17.0%
90	66548	7.8%
180	42948	5.1%
225	21868	2.6%
360	13047	1.5%
315	11616	1.4%
45	5335	0.6%
135	3818	0.5%
86	2099	0.2%
Other values (351)	232566	27.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	304105	35.8%
1	175	< 0.1%
2	277	< 0.1%
3	150	< 0.1%
4	150	< 0.1%
5	222	< 0.1%
6	240	< 0.1%
7	204	< 0.1%
8	193	< 0.1%
9	150	< 0.1%

Value	Count	Frequency (%)
360	13047	1.5%
359	132	< 0.1%
358	228	< 0.1%
357	271	< 0.1%
356	264	< 0.1%
355	193	< 0.1%
354	180	< 0.1%
353	198	< 0.1%
352	192	< 0.1%
351	283	< 0.1%

BrightnessNorth
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	469
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.861957945

Minimum	0
Maximum	60.09999847
Zeros	414876
Zeros (%)	48.9%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.1000000015
Q3	6.900000095
95-th percentile	23
Maximum	60.09999847
Range	60.09999847
Interquartile range (IQR)	6.900000095

Descriptive statistics

Standard deviation	8.102571487
Coefficient of variation (CV)	1.666524388
Kurtosis	4.848392487
Mean	4.861957945
Median Absolute Deviation (MAD)	0.1000000015
Skewness	2.174777746
Sum	4124938.602
Variance	65.65166473
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	414876	48.9%
0.1000000015	10143	1.2%
0.200000003	9331	1.1%
0.5	6450	0.8%
0.8000000119	5615	0.7%
0.400000006	5568	0.7%
0.3000000119	5077	0.6%
1	4652	0.5%
0.6999999881	4532	0.5%
1.100000024	4317	0.5%
Other values (459)	377850	44.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	414876	48.9%
0.1000000015	10143	1.2%
0.200000003	9331	1.1%
0.3000000119	5077	0.6%
0.400000006	5568	0.7%
0.5	6450	0.8%
0.6000000238	3189	0.4%
0.6999999881	4532	0.5%
0.8000000119	5615	0.7%
0.8999999762	2807	0.3%

Value	Count	Frequency (%)
60.09999847	6	< 0.1%
55.90000153	6	< 0.1%
55.59999847	6	< 0.1%
54.59999847	13	< 0.1%
53.59999847	20	< 0.1%
53.29999924	6	< 0.1%
52.90000153	6	< 0.1%
52.79999924	6	< 0.1%
52.09999847	12	< 0.1%
51.90000153	6	< 0.1%

BrightnessEast
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	772
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.33560939

Minimum	0
Maximum	145.3000031
Zeros	414388
Zeros (%)	48.8%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.1000000015
Q3	8.5
95-th percentile	67.90000153
Maximum	145.3000031
Range	145.3000031
Interquartile range (IQR)	8.5

Descriptive statistics

Standard deviation	21.67531967
Coefficient of variation (CV)	2.097149655
Kurtosis	7.137229443
Mean	10.33560939
Median Absolute Deviation (MAD)	0.1000000015
Skewness	2.7415061
Sum	8768844.699
Variance	469.819458
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	414388	48.8%
0.1000000015	10310	1.2%
0.200000003	8679	1.0%
0.5	6651	0.8%
0.8000000119	5420	0.6%
0.400000006	5403	0.6%
0.3000000119	4922	0.6%
1.100000024	4527	0.5%
1.299999952	4113	0.5%
1	4095	0.5%
Other values (762)	379903	44.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	414388	48.8%
0.1000000015	10310	1.2%
0.200000003	8679	1.0%
0.3000000119	4922	0.6%
0.400000006	5403	0.6%
0.5	6651	0.8%
0.6000000238	3161	0.4%
0.6999999881	4065	0.5%
0.8000000119	5420	0.6%
0.8999999762	2743	0.3%

Value	Count	Frequency (%)
145.3000031	6	< 0.1%
143.6000061	6	< 0.1%
142.8000031	6	< 0.1%
141.8999939	6	< 0.1%
140.6000061	6	< 0.1%
140.1999969	6	< 0.1%
139.8000031	6	< 0.1%
139	6	< 0.1%
138.1000061	6	< 0.1%
137.3000031	6	< 0.1%

BrightnessSouth
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	784
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.62331134

Minimum	0
Maximum	158.3999939
Zeros	415732
Zeros (%)	49.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.1000000015
Q3	9.5
95-th percentile	75.59999847
Maximum	158.3999939
Range	158.3999939
Interquartile range (IQR)	9.5

Descriptive statistics

Standard deviation	23.80919266
Coefficient of variation (CV)	2.048400147
Kurtosis	5.854674816
Mean	11.62331134
Median Absolute Deviation (MAD)	0.1000000015
Skewness	2.54088974
Sum	9861345.195
Variance	566.8776245
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	415732	49.0%
0.1000000015	10508	1.2%
0.200000003	8992	1.1%
0.5	6397	0.8%
0.8000000119	5857	0.7%
0.400000006	5763	0.7%
0.3000000119	5089	0.6%
0.6999999881	4469	0.5%
1.100000024	4284	0.5%
1	4260	0.5%
Other values (774)	377060	44.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	415732	49.0%
0.1000000015	10508	1.2%
0.200000003	8992	1.1%
0.3000000119	5089	0.6%
0.400000006	5763	0.7%
0.5	6397	0.8%
0.6000000238	3458	0.4%
0.6999999881	4469	0.5%
0.8000000119	5857	0.7%
0.8999999762	2943	0.3%

Value	Count	Frequency (%)
158.3999939	19	< 0.1%
158	6	< 0.1%
157.6000061	6	< 0.1%
155.8999939	6	< 0.1%
147.8000031	12	< 0.1%
146.1000061	6	< 0.1%
145.3000031	12	< 0.1%
144	18	< 0.1%
142.8000031	6	< 0.1%
142.3000031	18	< 0.1%

BrightnessWest
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	743
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.974496199

Minimum	0
Maximum	147.3999939
Zeros	413508
Zeros (%)	48.7%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.200000003
Q3	8.899999619
95-th percentile	51.59999847
Maximum	147.3999939
Range	147.3999939
Interquartile range (IQR)	8.899999619

Descriptive statistics

Standard deviation	18.51635933
Coefficient of variation (CV)	2.06321992
Kurtosis	9.912195206
Mean	8.974496199
Median Absolute Deviation (MAD)	0.200000003
Skewness	3.050058842
Sum	7614061.295
Variance	342.8555298
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	413508	48.7%
0.1000000015	9893	1.2%
0.200000003	8063	1.0%
0.5	5945	0.7%
0.400000006	5174	0.6%
0.3000000119	4861	0.6%
0.8000000119	4850	0.6%
1	3886	0.5%
1.100000024	3878	0.5%
0.6999999881	3800	0.4%
Other values (733)	384553	45.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	413508	48.7%
0.1000000015	9893	1.2%
0.200000003	8063	1.0%
0.3000000119	4861	0.6%
0.400000006	5174	0.6%
0.5	5945	0.7%
0.6000000238	2910	0.3%
0.6999999881	3800	0.4%
0.8000000119	4850	0.6%
0.8999999762	2947	0.3%

Value	Count	Frequency (%)
147.3999939	6	< 0.1%
143.6000061	6	< 0.1%
143.1999969	6	< 0.1%
140.6000061	12	< 0.1%
138.1000061	6	< 0.1%
137.3000031	6	< 0.1%
136	6	< 0.1%
135.6000061	6	< 0.1%
133	6	< 0.1%
129.6999969	6	< 0.1%

Beamerstate
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	46.9 MiB

0	809155
1	39256

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	848411
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	809155	95.4%
1	39256	4.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	809155	95.4%
1	39256	4.6%

Most occurring characters

Value	Count	Frequency (%)
0	809155	95.4%
1	39256	4.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	848411	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	809155	95.4%
1	39256	4.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	848411	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	809155	95.4%
1	39256	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	848411	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	809155	95.4%
1	39256	4.6%

BucketAttendees
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.04579384284

Minimum	0
Maximum	6
Zeros	818422
Zeros (%)	96.5%
Negative	0
Negative (%)	0.0%
Memory size	6.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2730726726
Coefficient of variation (CV)	5.963087079
Kurtosis	84.23380299
Mean	0.04579384284
Median Absolute Deviation (MAD)	0
Skewness	8.11346996
Sum	38852
Variance	0.0745686845
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	818422	96.5%
1	24428	2.9%
2	3109	0.4%
3	1676	0.2%
4	709	0.1%
5	60	< 0.1%
6	7	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	818422	96.5%
1	24428	2.9%
2	3109	0.4%
3	1676	0.2%
4	709	0.1%
5	60	< 0.1%
6	7	< 0.1%

Value	Count	Frequency (%)
6	7	< 0.1%
5	60	< 0.1%
4	709	0.1%
3	1676	0.2%
2	3109	0.4%
1	24428	2.9%
0	818422	96.5%

dwpt
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2806
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.12271461

Minimum	-22.8
Maximum	23
Zeros	1878
Zeros (%)	0.2%
Negative	128952
Negative (%)	15.2%
Memory size	6.5 MiB

Quantile statistics

Minimum	-22.8
5-th percentile	-3.3
Q1	1.7
median	6.15
Q3	10.85
95-th percentile	15.6
Maximum	23
Range	45.8
Interquartile range (IQR)	9.15

Descriptive statistics

Standard deviation	6.114669039
Coefficient of variation (CV)	0.9986859471
Kurtosis	0.02577060591
Mean	6.12271461
Median Absolute Deviation (MAD)	4.55
Skewness	-0.2833830907
Sum	5194578.425
Variance	37.38917746
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.5	2768	0.3%
1.9	2662	0.3%
1.4	2656	0.3%
2.1	2629	0.3%
2	2617	0.3%
1.1	2617	0.3%
0.7	2593	0.3%
8.3	2536	0.3%
5.1	2521	0.3%
3.5	2515	0.3%
Other values (2796)	822297	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-22.8	6	< 0.1%
-22.75	6	< 0.1%
-22.7	6	< 0.1%
-22.65	6	< 0.1%
-22.6	6	< 0.1%
-22.5	6	< 0.1%
-22.325	6	< 0.1%
-22.2	6	< 0.1%
-22.05	6	< 0.1%
-22	6	< 0.1%

Value	Count	Frequency (%)
23	6	< 0.1%
22.525	6	< 0.1%
22.4	6	< 0.1%
22.05	6	< 0.1%
21.8	12	< 0.1%
21.625	6	< 0.1%
21.575	6	< 0.1%
21.575	6	< 0.1%
21.45	6	< 0.1%
21.35	6	< 0.1%

rhum
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	330
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77.09964186

Minimum	0
Maximum	100
Zeros	18
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.5 MiB

Quantile statistics

Minimum	0
5-th percentile	41.5
Q1	67
median	81.5
Q3	90.75
95-th percentile	98
Maximum	100
Range	100
Interquartile range (IQR)	23.75

Descriptive statistics

Standard deviation	17.41226757
Coefficient of variation (CV)	0.2258410954
Kurtosis	-0.009567350005
Mean	77.09964186
Median Absolute Deviation (MAD)	11
Skewness	-0.8783361371
Sum	65412184.25
Variance	303.187062
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	12188	1.4%
98	12137	1.4%
93	11856	1.4%
95	11845	1.4%
100	11826	1.4%
96	11787	1.4%
89	11717	1.4%
84	11712	1.4%
91	11648	1.4%
92	11617	1.4%
Other values (320)	730078	86.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	< 0.1%
17	6	< 0.1%
18	42	< 0.1%
18.25	6	< 0.1%
18.5	18	< 0.1%
18.75	6	< 0.1%
19	78	< 0.1%
19.5	24	< 0.1%
19.75	12	< 0.1%
20	42	< 0.1%

Value	Count	Frequency (%)
100	11826	1.4%
99.75	2022	0.2%
99.5	2586	0.3%
99.25	2190	0.3%
99	11148	1.3%
98.75	2528	0.3%
98.5	4172	0.5%
98.25	2864	0.3%
98	12137	1.4%
97.75	2611	0.3%

prcp
Real number (ℝ_≥0)

ZEROS

Distinct	470
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.07265720859

Minimum	0
Maximum	26.2
Zeros	734300
Zeros (%)	86.6%
Negative	0
Negative (%)	0.0%
Memory size	6.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.375
Maximum	26.2
Range	26.2
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4150709894
Coefficient of variation (CV)	5.712729644
Kurtosis	563.5979352
Mean	0.07265720859
Median Absolute Deviation (MAD)	0
Skewness	17.65664282
Sum	61643.175
Variance	0.1722839262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	734300	86.6%
0.1	13368	1.6%
0.05	8305	1.0%
0.075	7609	0.9%
0.2	6362	0.7%
0.15	4444	0.5%
0.025	3550	0.4%
0.3	3450	0.4%
0.4	3306	0.4%
0.025	3260	0.4%
Other values (460)	60457	7.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	734300	86.6%
0.025	3550	0.4%
0.025	3260	0.4%
0.05	1527	0.2%
0.05	8305	1.0%
0.075	721	0.1%
0.075	7609	0.9%
0.1	457	0.1%
0.1	13368	1.6%
0.125	1960	0.2%

Value	Count	Frequency (%)
26.2	6	< 0.1%
21.8	6	< 0.1%
21.15	6	< 0.1%
20.225	6	< 0.1%
18.5	6	< 0.1%
17.5	6	< 0.1%
17	6	< 0.1%
16.5	6	< 0.1%
16.4	6	< 0.1%
16.1	6	< 0.1%

wspd
Real number (ℝ_≥0)

Distinct	2182
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.03301996

Minimum	0
Maximum	54
Zeros	18
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.5 MiB

Quantile statistics

Minimum	0
5-th percentile	3.625
Q1	7.125
median	10.95
Q3	15.725
95-th percentile	24.3
Maximum	54
Range	54
Interquartile range (IQR)	8.6

Descriptive statistics

Standard deviation	6.444632637
Coefficient of variation (CV)	0.5355789865
Kurtosis	0.9798285413
Mean	12.03301996
Median Absolute Deviation (MAD)	4.15
Skewness	0.9269693532
Sum	10208946.5
Variance	41.53328983
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.4	8198	1.0%
9	8077	1.0%
10.8	7957	0.9%
7.2	7936	0.9%
6.1	7928	0.9%
6.5	7704	0.9%
8.3	7481	0.9%
9.7	7473	0.9%
7.6	7218	0.9%
10.1	7057	0.8%
Other values (2172)	771382	90.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18	< 0.1%
0.4	54	< 0.1%
0.475	24	< 0.1%
0.55	24	< 0.1%
0.625	24	< 0.1%
0.7	162	< 0.1%
0.75	12	< 0.1%
0.8	30	< 0.1%
0.85	6	< 0.1%
0.875	48	< 0.1%

Value	Count	Frequency (%)
54	6	< 0.1%
52.375	6	< 0.1%
52.2	12	< 0.1%
51.4	6	< 0.1%
51.125	6	< 0.1%
50.75	6	< 0.1%
50.6	6	< 0.1%
50.4	6	< 0.1%
50.05	6	< 0.1%
49.8	6	< 0.1%

tsun
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	281
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.09812726

Minimum	0
Maximum	60
Zeros	568344
Zeros (%)	67.0%
Negative	0
Negative (%)	0.0%
Memory size	6.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	10.75
95-th percentile	60
Maximum	60
Range	60
Interquartile range (IQR)	10.75

Descriptive statistics

Standard deviation	20.33364974
Coefficient of variation (CV)	1.832169452
Kurtosis	0.9171284956
Mean	11.09812726
Median Absolute Deviation (MAD)	0
Skewness	1.601715103
Sum	9415773.25
Variance	413.4573119
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	568344	67.0%
60	63656	7.5%
1	5070	0.6%
0.5	3738	0.4%
3	3707	0.4%
1.5	3542	0.4%
2	3304	0.4%
0.75	3294	0.4%
59	2938	0.3%
6	2647	0.3%
Other values (271)	188171	22.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	568344	67.0%
0.25	2208	0.3%
0.375	6	< 0.1%
0.5	3738	0.4%
0.75	3294	0.4%
1	5070	0.6%
1.125	6	< 0.1%
1.25	836	0.1%
1.416666667	6	< 0.1%
1.5	3542	0.4%

Value	Count	Frequency (%)
60	63656	7.5%
59.75	1161	0.1%
59.5	1750	0.2%
59.25	1610	0.2%
59.125	6	< 0.1%
59	2938	0.3%
58.75	511	0.1%
58.5	1516	0.2%
58.25	546	0.1%
58	1954	0.2%

coco
Real number (ℝ_≥0)

ZEROS

Distinct	147
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.351226292

Minimum	0
Maximum	25
Zeros	15378
Zeros (%)	1.8%
Negative	0
Negative (%)	0.0%
Memory size	6.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2.25
median	4
Q3	6
95-th percentile	8
Maximum	25
Range	25
Interquartile range (IQR)	3.75

Descriptive statistics

Standard deviation	2.940262781
Coefficient of variation (CV)	0.6757319854
Kurtosis	4.024227738
Mean	4.351226292
Median Absolute Deviation (MAD)	2
Skewness	1.46220686
Sum	3691628.25
Variance	8.645145224
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	265065	31.2%
1	136257	16.1%
8	93397	11.0%
7	43759	5.2%
3	33720	4.0%
5	26974	3.2%
2	25616	3.0%
2.5	20264	2.4%
3.5	17872	2.1%
3.25	17666	2.1%
Other values (137)	167821	19.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15378	1.8%
1	136257	16.1%
1.083333333	18	< 0.1%
1.083333333	6	< 0.1%
1.125	18	< 0.1%
1.166666667	24	< 0.1%
1.25	6573	0.8%
1.333333333	18	< 0.1%
1.333333333	6	< 0.1%
1.375	30	< 0.1%

Value	Count	Frequency (%)
25	360	< 0.1%
23.25	18	< 0.1%
23	6	< 0.1%
21.5	18	< 0.1%
21	738	0.1%
20.75	6	< 0.1%
20.25	12	< 0.1%
19.75	24	< 0.1%
19.5	24	< 0.1%
19.25	24	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	Room	RoomTemperature	TempSupplyAir	RelativeHumiditySupplyAir	CoolingPower	AirTemperature	WindDirection	dwpt	rhum	wspd
0	2018-01-01 00:00:00	0.0	21.299999	18.40	40.799999	1.4	9.5	235	6.5	81.0	22.3
1	2018-01-01 00:00:00	1.0	21.600000	18.40	40.799999	1.4	9.5	235	6.5	81.0	22.3
2	2018-01-01 00:00:00	2.0	21.799999	18.40	40.799999	1.4	9.5	235	6.5	81.0	22.3
3	2018-01-01 00:00:00	3.0	21.900000	18.40	40.799999	1.4	9.5	235	6.5	81.0	22.3
4	2018-01-01 00:00:00	4.0	20.400000	18.40	40.799999	1.4	9.5	235	6.5	81.0	22.3
5	2018-01-01 00:00:00	5.0	21.900000	18.40	40.799999	1.4	9.5	235	6.5	81.0	22.3
6	2018-01-01 00:15:00	0.0	21.299999	18.33	40.799999	0.5	9.5	253	6.3	80.0	22.4
7	2018-01-01 00:15:00	1.0	21.600000	18.33	40.799999	0.5	9.5	253	6.3	80.0	22.4
8	2018-01-01 00:15:00	2.0	21.900000	18.33	40.799999	0.5	9.5	253	6.3	80.0	22.4
9	2018-01-01 00:15:00	3.0	21.900000	18.33	40.799999	0.5	9.5	253	6.3	80.0	22.4

Last rows

	df_index	Room	RoomTemperature	AirqualityPerc	HeaterPerc	CoolerPerc	TempSupplyAir	RelativeHumiditySupplyAir	CoolingPower	AirTemperature	WindDirection	Beamerstate
848401	2021-12-31 23:30:00	2.0	19.600000	23.700001	1.4	0.9	17.530001	38.000000	0.2	12.9	270	1
848402	2021-12-31 23:30:00	3.0	19.000000	9.000000	1.4	0.9	17.530001	38.000000	0.2	12.9	270	0
848403	2021-12-31 23:30:00	4.0	18.299999	20.200001	1.4	0.9	17.530001	38.000000	0.2	12.9	270	0
848404	2021-12-31 23:30:00	5.0	18.799999	25.100000	1.4	0.9	17.530001	38.000000	0.2	12.9	270	0
848405	2021-12-31 23:45:00	0.0	18.500000	16.799999	1.3	0.9	17.590000	38.099998	0.2	12.7	315	0
848406	2021-12-31 23:45:00	1.0	19.400000	21.000000	1.3	0.9	17.590000	38.099998	0.2	12.7	315	0
848407	2021-12-31 23:45:00	2.0	19.600000	23.600000	1.3	0.9	17.590000	38.099998	0.2	12.7	315	1
848408	2021-12-31 23:45:00	3.0	19.000000	9.200000	1.3	0.9	17.590000	38.099998	0.2	12.7	315	0
848409	2021-12-31 23:45:00	4.0	18.299999	20.200001	1.3	0.9	17.590000	38.099998	0.2	12.7	315	0
848410	2021-12-31 23:45:00	5.0	18.900000	25.200001	1.3	0.9	17.590000	38.099998	0.2	12.7	315	0

Most frequently occurring

	df_index	Room	RoomTemperature	HeaterPerc	TempSupplyAir	RelativeHumiditySupplyAir	AirTemperature	WindDirection	dwpt	rhum	wspd	coco	# duplicates
96	2018-10-28 02:30:00	4.0	20.9	0.0	19.48	42.000000	3.600000	86	1.850	89.50	12.4	4.0	64
97	2018-10-28 02:30:00	4.0	20.9	0.0	19.48	42.000000	4.000000	0	1.850	89.50	12.4	4.0	64
98	2018-10-28 02:30:00	5.0	22.6	0.0	19.48	42.000000	3.600000	86	1.850	89.50	12.4	4.0	64
99	2018-10-28 02:30:00	5.0	22.6	0.0	19.48	42.000000	4.000000	0	1.850	89.50	12.4	4.0	64
124	2018-10-28 02:45:00	4.0	20.9	0.0	19.48	42.000000	3.600000	61	1.825	89.25	12.5	4.0	64
125	2018-10-28 02:45:00	4.0	20.9	0.0	19.48	42.000000	4.000000	360	1.825	89.25	12.5	4.0	64
126	2018-10-28 02:45:00	5.0	22.6	0.0	19.48	42.000000	3.600000	61	1.825	89.25	12.5	4.0	64
127	2018-10-28 02:45:00	5.0	22.6	0.0	19.48	42.000000	4.000000	360	1.825	89.25	12.5	4.0	64
144	2019-10-27 02:00:00	4.0	21.9	1.6	20.01	42.700001	16.200001	207	10.500	67.00	24.1	4.0	64
145	2019-10-27 02:00:00	4.0	21.9	1.6	20.01	42.700001	17.400000	269	10.500	67.00	24.1	4.0	64

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequently occurring